home *** CD-ROM | disk | FTP | other *** search
/ SGI Freeware 2001 May / SGI Freeware 2001 May - Disc 1.iso / dist / fw_mysql.idb / usr / freeware / share / sql-bench / limits / pg.cfg.z / pg.cfg
Encoding:
Text File  |  1999-10-18  |  18.4 KB  |  428 lines
  1. #This file is automaticly generated by crash-me 1.21
  2.  
  3. NEG=no                    # update of column= -column
  4. alter_add_col=yes            # Alter table add column
  5. alter_add_multi_col=no            # Alter table add many columns
  6. alter_alter_col=no            # Alter table alter column
  7. alter_change_col=no            # Alter table change column
  8. alter_drop_col=no            # Alter table drop column
  9. alter_modify_col=no            # Alter table modify column
  10. alter_rename_table=no            # Alter table rename table
  11. atomic_updates=no            # atomic updates
  12. binary_items=no                # binary items (0x41)
  13. case_insensitive_strings=no        # case insensitive compare
  14. char_is_space_filled=no            # char are space filled
  15. column_alias=yes            # Column alias
  16. columns_in_group_by=+64            # number of columns in group by
  17. columns_in_order_by=+64            # number of columns in order by
  18. comment_#=no                # # as comment
  19. comment_--=no                # -- as comment
  20. comment_/**/=yes            # /* */ as comment
  21. compute=no                # Compute
  22. connections=64                # Simultaneous connections
  23. crash_me_safe=yes            # crash me safe
  24. crash_me_version=1.21            # crash me version
  25. create_default=yes            # default value for column
  26. create_index=yes            # create index
  27. cross_join=no                # cross join (same as from a,b)
  28. date_with_YY=yes            # Supports YY-MM-DD 2000 compilant dates
  29. date_zero=no                # Supports 0000-00-00 dates
  30. double_quotes=yes            # Double '' as ' in strings
  31. drop_index=yes                # drop index
  32. end_colon=yes                # allows end ';'
  33. except=no                # except
  34. except_all=no                # except all
  35. float_int_expr=yes            # mixing of integer and float in expression
  36. foreign_key=no                # foreign keys
  37. foreign_key_syntax=yes            # foreign key syntax
  38. full_outer_join=no            # full outer join
  39. func_extra_!=no                # Function NOT as '!' in SELECT
  40. func_extra_%=yes            # Function MOD as %
  41. func_extra_&=no                # Function & (bitwise and)
  42. func_extra_&&=no            # Function AND as '&&'
  43. func_extra_<>=yes            # Function <> in SELECT
  44. func_extra_==yes            # Function =
  45. func_extra_add_months=no        # Function ADD_MONTHS
  46. func_extra_and_or=yes            # Function AND and OR in SELECT
  47. func_extra_atn2=no            # Function ATN2
  48. func_extra_auto_num2string=no        # Function automatic num->string convert
  49. func_extra_auto_string2num=yes        # Function automatic string->num convert
  50. func_extra_between=yes            # Function BETWEEN in SELECT
  51. func_extra_binary_shifts=no        # Function << and >> (bitwise shifts)
  52. func_extra_bit_count=no            # Function BIT_COUNT
  53. func_extra_ceil=no            # Function CEIL
  54. func_extra_charindex=no            # Function CHARINDEX
  55. func_extra_chr=no            # Function CHR
  56. func_extra_concat_as_+=no        # Function concatenation with +
  57. func_extra_concat_list=no        # Function CONCAT(list)
  58. func_extra_convert=no            # Function CONVERT
  59. func_extra_cosh=no            # Function COSH
  60. func_extra_date_format=no        # Function DATE_FORMAT
  61. func_extra_dateadd=no            # Function DATEADD
  62. func_extra_datediff=no            # Function DATEDIFF
  63. func_extra_datename=no            # Function DATENAME
  64. func_extra_datepart=no            # Function DATEPART
  65. func_extra_elt=no            # Function ELT
  66. func_extra_encrypt=no            # Function ENCRYPT
  67. func_extra_field=no            # Function FIELD
  68. func_extra_format=no            # Function FORMAT
  69. func_extra_from_days=no            # Function FROM_DAYS
  70. func_extra_from_unixtime=no        # Function FROM_UNIXTIME
  71. func_extra_getdate=no            # Function GETDATE
  72. func_extra_greatest=no            # Function GREATEST
  73. func_extra_if=no            # Function IF
  74. func_extra_in_num=yes            # Function IN on numbers in SELECT
  75. func_extra_in_str=no            # Function IN on strings in SELECT
  76. func_extra_initcap=yes            # Function INITCAP
  77. func_extra_instr=no            # Function LOCATE as INSTR
  78. func_extra_instrb=no            # Function INSTRB
  79. func_extra_interval=no            # Function INTERVAL
  80. func_extra_last_day=no            # Function LAST_DAY
  81. func_extra_last_insert_id=no        # Function LAST_INSERT_ID
  82. func_extra_least=no            # Function LEAST
  83. func_extra_lengthb=no            # Function LENGTHB
  84. func_extra_like=no            # Function LIKE in SELECT
  85. func_extra_like_escape=no        # Function LIKE ESCAPE in SELECT
  86. func_extra_ln=no            # Function LN
  87. func_extra_log(m_n)=no            # Function LOG(m,n)
  88. func_extra_logn=no            # Function LOGN
  89. func_extra_lpad=yes            # Function LPAD
  90. func_extra_mdy=no            # Function MDY
  91. func_extra_mid=no            # Function SUBSTRING as MID
  92. func_extra_months_between=no        # Function MONTHS_BETWEEN
  93. func_extra_not=no            # Function NOT in SELECT
  94. func_extra_not_between=yes        # Function NOT BETWEEN in SELECT
  95. func_extra_not_like=no            # Function NOT LIKE in SELECT
  96. func_extra_odbc_convert=no        # Function ODBC CONVERT
  97. func_extra_password=no            # Function PASSWORD
  98. func_extra_patindex=no            # Function PATINDEX
  99. func_extra_period_add=no        # Function PERIOD_ADD
  100. func_extra_period_diff=no        # Function PERIOD_DIFF
  101. func_extra_pow=no            # Function POW
  102. func_extra_range=no            # Function RANGE
  103. func_extra_regexp=no            # Function REGEXP in SELECT
  104. func_extra_replicate=no            # Function REPLICATE
  105. func_extra_reverse=no            # Function REVERSE
  106. func_extra_root=no            # Function ROOT
  107. func_extra_round1=no            # Function ROUND(1 arg)
  108. func_extra_rpad=yes            # Function RPAD
  109. func_extra_sec_to_time=no        # Function SEC_TO_TIME
  110. func_extra_sinh=no            # Function SINH
  111. func_extra_str=no            # Function STR
  112. func_extra_strcmp=no            # Function STRCMP
  113. func_extra_stuff=no            # Function STUFF
  114. func_extra_substrb=no            # Function SUBSTRB
  115. func_extra_substring_index=no        # Function SUBSTRING_INDEX
  116. func_extra_tanh=no            # Function TANH
  117. func_extra_time_to_sec=no        # Function TIME_TO_SEC
  118. func_extra_to_days=no            # Function TO_DAYS
  119. func_extra_translate=error        # Function TRANSLATE
  120. func_extra_trim_many_char=yes        # Function TRIM; Many char extension
  121. func_extra_trim_substring=error        # Function TRIM; Substring extension
  122. func_extra_trunc=no            # Function TRUNC
  123. func_extra_uid=no            # Function UID
  124. func_extra_unix_timestamp=no        # Function UNIX_TIMESTAMP
  125. func_extra_userenv=no            # Function USERENV
  126. func_extra_version=yes            # Function VERSION
  127. func_extra_weekday=no            # Function WEEKDAY
  128. func_extra_|=no                # Function | (bitwise or)
  129. func_extra_||=no            # Function OR as '||'
  130. func_odbc_abs=no            # Function ABS
  131. func_odbc_acos=no            # Function ACOS
  132. func_odbc_ascii=no            # Function ASCII
  133. func_odbc_asin=no            # Function ASIN
  134. func_odbc_atan=no            # Function ATAN
  135. func_odbc_atan2=no            # Function ATAN2
  136. func_odbc_ceiling=no            # Function CEILING
  137. func_odbc_char=no            # Function CHAR
  138. func_odbc_concat=no            # Function CONCAT(2 arg)
  139. func_odbc_cos=no            # Function COS
  140. func_odbc_cot=no            # Function COT
  141. func_odbc_curdate=no            # Function CURDATE
  142. func_odbc_curtime=no            # Function CURTIME
  143. func_odbc_database=no            # Function DATABASE
  144. func_odbc_dayname=no            # Function DAYNAME
  145. func_odbc_dayofmonth=no            # Function DAYOFMONTH
  146. func_odbc_dayofweek=no            # Function DAYOFWEEK
  147. func_odbc_dayofyear=no            # Function DAYOFYEAR
  148. func_odbc_degrees=no            # Function DEGREES
  149. func_odbc_difference=no            # Function DIFFERENCE()
  150. func_odbc_exp=no            # Function EXP
  151. func_odbc_extract=no            # Function EXTRACT
  152. func_odbc_floor=no            # Function FLOOR
  153. func_odbc_fn_left=no            # Function ODBC syntax LEFT & RIGHT
  154. func_odbc_hour=no            # Function HOUR
  155. func_odbc_hour_time=no            # Function ANSI HOUR
  156. func_odbc_ifnull=no            # Function IFNULL
  157. func_odbc_insert=no            # Function INSERT
  158. func_odbc_lcase=no            # Function LCASE
  159. func_odbc_left=no            # Function LEFT
  160. func_odbc_length=no            # Function REAL LENGTH
  161. func_odbc_length_without_space=no    # Function ODBC LENGTH
  162. func_odbc_locate_2=no            # Function LOCATE(2 arg)
  163. func_odbc_locate_3=no            # Function LOCATE(3 arg)
  164. func_odbc_log=no            # Function LOG
  165. func_odbc_log10=no            # Function LOG10
  166. func_odbc_ltrim=yes            # Function LTRIM
  167. func_odbc_minute=no            # Function MINUTE
  168. func_odbc_mod=no            # Function MOD
  169. func_odbc_month=no            # Function MONTH
  170. func_odbc_monthname=no            # Function MONTHNAME
  171. func_odbc_now=yes            # Function NOW
  172. func_odbc_pi=no                # Function PI
  173. func_odbc_power=no            # Function POWER
  174. func_odbc_quarter=no            # Function QUARTER
  175. func_odbc_radians=no            # Function RADIANS
  176. func_odbc_rand=no            # Function RAND
  177. func_odbc_repeat=no            # Function REPEAT
  178. func_odbc_replace=no            # Function REPLACE
  179. func_odbc_right=no            # Function RIGHT
  180. func_odbc_round=no            # Function ROUND(2 arg)
  181. func_odbc_rtrim=yes            # Function RTRIM
  182. func_odbc_second=no            # Function SECOND
  183. func_odbc_sign=no            # Function SIGN
  184. func_odbc_sin=no            # Function SIN
  185. func_odbc_soundex=no            # Function SOUNDEX
  186. func_odbc_space=no            # Function SPACE
  187. func_odbc_sqrt=no            # Function SQRT
  188. func_odbc_substring=no            # Function ODBC SUBSTRING
  189. func_odbc_tan=no            # Function TAN
  190. func_odbc_timestampadd=no        # Function TIMESTAMPADD
  191. func_odbc_timestampdiff=no        # Function TIMESTAMPDIFF
  192. func_odbc_truncate=no            # Function TRUNCATE
  193. func_odbc_ucase=no            # Function UCASE
  194. func_odbc_user=yes            # Function USER
  195. func_odbc_user()=no            # Function USER()
  196. func_odbc_week=no            # Function WEEK
  197. func_odbc_year=no            # Function YEAR
  198. func_sql_+=yes                # Function +, -, * and /
  199. func_sql_bit_length=no            # Function BIT_LENGTH
  200. func_sql_case=no            # Function CASE
  201. func_sql_cast=yes            # Function CAST
  202. func_sql_char_length=no            # Function CHAR_LENGTH
  203. func_sql_character_length=no        # Function CHARACTER_LENGTH
  204. func_sql_concat_as_||=yes        # Function concatenation with ||
  205. func_sql_current_date=yes        # Function CURRENT_DATE
  206. func_sql_current_date()=no        # Function CURRENT_DATE()
  207. func_sql_current_time=yes        # Function CURRENT_TIME
  208. func_sql_current_time()=no        # Function CURRENT_TIME()
  209. func_sql_current_timestamp=yes        # Function CURRENT_TIMESTAMP
  210. func_sql_current_timestamp()=no        # Function CURRENT_TIMESTAMP()
  211. func_sql_lower=yes            # Function LOWER
  212. func_sql_octet_length=no        # Function OCTET_LENGTH
  213. func_sql_position=yes            # Function POSITION
  214. func_sql_session_user=no        # Function SESSION_USER
  215. func_sql_substring=yes            # Function ANSI SQL SUBSTRING
  216. func_sql_sysdate=no            # Function SYSDATE
  217. func_sql_system_user=no            # Function SYSTEM_USER
  218. func_sql_trim=yes            # Function TRIM
  219. func_sql_upper=yes            # Function UPPER
  220. func_where_between=yes            # Function BETWEEN
  221. func_where_eq_all=yes            # Function = ALL
  222. func_where_eq_any=yes            # Function = ANY
  223. func_where_eq_some=no            # Function = SOME
  224. func_where_exists=yes            # Function EXISTS
  225. func_where_in_num=yes            # Function IN on numbers
  226. func_where_like=yes            # Function LIKE
  227. func_where_like_escape=no        # Function LIKE ESCAPE
  228. func_where_match=no            # Function MATCH
  229. func_where_match_unique=no        # Function MATCH UNIQUE
  230. func_where_matches=no            # Function MATCHES
  231. func_where_not_between=yes        # Function NOT BETWEEN
  232. func_where_not_exists=yes        # Function NOT EXISTS
  233. func_where_not_like=yes            # Function NOT LIKE
  234. func_where_not_unique=no        # Function NOT UNIQUE
  235. func_where_unique=no            # Function UNIQUE
  236. functions=yes                # Functions
  237. group_by=yes                # Group by
  238. group_by_alias=yes            # Group by alias
  239. group_by_null=yes            # group on column with null values
  240. group_by_position=yes            # Group by position
  241. group_distinct_functions=no        # Group functions with distinct
  242. group_func_extra_bit_and=no        # Group function BIT_AND
  243. group_func_extra_bit_or=no        # Group function BIT_OR
  244. group_func_extra_std=no            # Group function STD
  245. group_func_extra_stddev=no        # Group function STDDEV
  246. group_func_extra_variance=no        # Group function VARIANCE
  247. group_func_sql_avg=yes            # Group function AVG
  248. group_func_sql_count_*=yes        # Group function COUNT (*)
  249. group_func_sql_count_column=yes        # Group function COUNT column name
  250. group_func_sql_count_distinct=no    # Group function COUNT DISTINCT column name
  251. group_func_sql_max=yes            # Group function MAX on numbers
  252. group_func_sql_max_str=no        # Group function MAX on strings
  253. group_func_sql_min=yes            # Group function MIN on numbers
  254. group_func_sql_min_str=no        # Group function MIN on strings
  255. group_func_sql_sum=yes            # Group function SUM
  256. group_functions=yes            # Group functions
  257. having=no                # Having
  258. having_with_alias=no            # Having with alias
  259. ignore_end_space=yes            # ignore end space in compare
  260. index_in_create=no            # index in create table
  261. index_namespace=no            # different namespace for index
  262. index_parts=no                # index on column part (extension)
  263. insert_empty_string=yes            # insert empty string
  264. insert_select=yes            # insert INTO ... SELECT ...
  265. insert_with_set=no            # INSERT with set syntax
  266. intersect=no                # intersect
  267. intersect_all=no            # intersect all
  268. join_tables=36                # tables in join
  269. left_outer_join=no            # left outer join
  270. left_outer_join_using=no        # left outer join using
  271. like_with_column=yes            # column LIKE column
  272. like_with_number=no            # LIKE on numbers
  273. lock_tables=no                # lock table
  274. logical_value=1                # Value of logical operation (1=1)
  275. max_big_expressions=1            # big expressions
  276. max_char_size=4096            # max char() size
  277. max_column_name=+512            # column name length
  278. max_columns=637                # Columns in table
  279. max_conditions=18            # OR and AND in WHERE
  280. max_expressions=4091            # simple expressions
  281. max_index=+64                # max index
  282. max_index_length=8128            # index length
  283. max_index_name=+512            # index name length
  284. max_index_part_length=4096        # max index part length
  285. max_index_parts=6            # index parts
  286. max_index_varchar_part_length=4092    # index varchar part length
  287. max_row_length=7977            # max table row length (without blobs)
  288. max_row_length_with_null=7977        # table row length with nulls (without blobs)
  289. max_select_alias_name=+512        # select alias name length
  290. max_stack_expression=2045        # stacked expressions
  291. max_table_alias_name=+512        # table alias name length
  292. max_table_name=+512            # table name length
  293. max_text_size=8132            # max text or blob size
  294. max_unique_index=+64            # unique indexes
  295. max_varchar_size=4092            # max varchar() size
  296. minus=no                # minus
  297. minus_neg=yes                # Calculate 1--1
  298. multi_drop=yes                # many tables to drop table
  299. multi_strings=yes            # Multiple line strings
  300. multi_table_delete=no            # DELETE FROM table1,table2...
  301. multi_table_update=no            # Update with many tables
  302. multi_value_insert=no            # Value lists in INSERT
  303. natural_join=no                # natural join
  304. natural_left_outer_join=no        # natural left outer join
  305. no_primary_key=yes            # Tables without primary key
  306. null_concat_expr=no            # Is 'a' || NULL = NULL
  307. null_in_index=yes            # null in index
  308. null_in_unique=yes            # null in unique
  309. null_num_expr=no            # Is 1+NULL = NULL
  310. odbc_left_outer_join=no            # left outer join odbc style
  311. operating_system=Linux 2.0.36 i686    # crash-me tested on
  312. order_by=yes                # Order by
  313. order_by_alias=yes            # Order by alias
  314. order_by_position=yes            # Order by position
  315. primary_key_in_create=yes        # primary key in create table
  316. query_size=8191                # query size
  317. quote_with_"=no                # Allows ' and " as string markers
  318. recursive_subqueries=23            # recursive subqueries
  319. remember_end_space=no            # Remembers end space in char()
  320. remember_end_space_varchar=yes        # Remembers end space in varchar()
  321. right_outer_join=no            # right outer join
  322. select_constants=yes            # Select constants
  323. select_string_size=8182            # constant string size in SELECT
  324. select_table_update=no            # Update with sub select
  325. select_without_from=yes            # SELECT without FROM
  326. server_version=PostgreSQL 6.4        # server version
  327. simple_joins=yes            # ANSI SQL simple joins
  328. subqueries=yes                # subqueries
  329. table_alias=yes                # Table alias
  330. table_name_case=yes            # case independent table names
  331. table_wildcard=yes            # Select table_name.*
  332. transactions=yes            # transactions
  333. type_extra_abstime=yes            # Type abstime
  334. type_extra_bfile=no            # Type bfile
  335. type_extra_blob=no            # Type blob
  336. type_extra_bool=yes            # Type bool
  337. type_extra_box=yes            # Type box
  338. type_extra_byte=no            # Type byte
  339. type_extra_char(1_arg)_binary=no        # Type char(1_arg) binary
  340. type_extra_char16=no            # Type char16
  341. type_extra_char2=no            # Type char2
  342. type_extra_char4=no            # Type char4
  343. type_extra_char8=no            # Type char8
  344. type_extra_circle=yes            # Type circle
  345. type_extra_clob=no            # Type clob
  346. type_extra_datetime=yes            # Type datetime
  347. type_extra_enum(1_arg)=no            # Type enum(1_arg)
  348. type_extra_float(1_arg)=yes            # Type float(1_arg)
  349. type_extra_float4=yes            # Type float4
  350. type_extra_float8=yes            # Type float8
  351. type_extra_image=no            # Type image
  352. type_extra_int(1_arg)_zerofill=no        # Type int(1_arg) zerofill
  353. type_extra_int1=no            # Type int1
  354. type_extra_int2=yes            # Type int2
  355. type_extra_int3=no            # Type int3
  356. type_extra_int4=yes            # Type int4
  357. type_extra_int8=yes            # Type int8
  358. type_extra_int_auto_increment=no    # Type int not null auto_increment
  359. type_extra_int_unsigned=no        # Type int unsigned
  360. type_extra_line=yes            # Type line
  361. type_extra_long=no            # Type long
  362. type_extra_long_raw=no            # Type long raw
  363. type_extra_long_varbinary=no        # Type long varbinary
  364. type_extra_long_varchar(1_arg)=no        # Type long varchar(1_arg)
  365. type_extra_lseg=yes            # Type lseg
  366. type_extra_mediumint=no            # Type mediumint
  367. type_extra_mediumtext=no        # Type mediumtext
  368. type_extra_middleint=no            # Type middleint
  369. type_extra_mlslabel=no            # Type mlslabel
  370. type_extra_money=yes            # Type money
  371. type_extra_nchar(1_arg)=yes            # Type nchar(1_arg)
  372. type_extra_nclob=no            # Type nclob
  373. type_extra_number=no            # Type number
  374. type_extra_number(1_arg)=no            # Type number(1_arg)
  375. type_extra_nvarchar(2_arg)=no        # Type nvarchar(2_arg)
  376. type_extra_nvarchar2(1_arg)=no        # Type nvarchar2(1_arg)
  377. type_extra_path=yes            # Type path
  378. type_extra_point=yes            # Type point
  379. type_extra_polygon=yes            # Type polygon
  380. type_extra_raw(1_arg)=no            # Type raw(1_arg)
  381. type_extra_reltime=yes            # Type reltime
  382. type_extra_rowid=no            # Type rowid
  383. type_extra_serial=yes            # Type serial
  384. type_extra_set(1_arg)=no            # Type set(1_arg)
  385. type_extra_smalldatetime=no        # Type smalldatetime
  386. type_extra_smallfloat=no        # Type smallfloat
  387. type_extra_smallmoney=no        # Type smallmoney
  388. type_extra_text=yes            # Type text
  389. type_extra_text(1_arg)=no            # Type text(1_arg)
  390. type_extra_timespan=yes            # Type timespan
  391. type_extra_uint=no            # Type uint
  392. type_extra_varchar2(1_arg)=no        # Type varchar2(1_arg)
  393. type_extra_year=no            # Type year
  394. type_odbc_bigint=no            # Type bigint
  395. type_odbc_binary(1_arg)=no            # Type binary(1_arg)
  396. type_odbc_datetime=yes            # Type datetime
  397. type_odbc_smallint=yes            # Type smallint
  398. type_odbc_tinyint=no            # Type tinyint
  399. type_odbc_varbinary(1_arg)=no        # Type varbinary(1_arg)
  400. type_sql_bit=no                # Type bit
  401. type_sql_bit(1_arg)=no            # Type bit(1_arg)
  402. type_sql_bit_varying(1_arg)=no        # Type bit varying(1_arg)
  403. type_sql_char(1_arg)=yes            # Type char(1_arg)
  404. type_sql_char_varying(1_arg)=yes        # Type char varying(1_arg)
  405. type_sql_character(1_arg)=yes        # Type character(1_arg)
  406. type_sql_character_varying(1_arg)=yes    # Type character varying(1_arg)
  407. type_sql_date=yes            # Type date
  408. type_sql_dec(2_arg)=no            # Type dec(1_arg)
  409. type_sql_decimal(2_arg)=no            # Type decimal(1_arg)
  410. type_sql_double=no            # Type double
  411. type_sql_double_precision=yes        # Type double precision
  412. type_sql_float=yes            # Type float
  413. type_sql_float(2_arg)=no            # Type float(1_arg)
  414. type_sql_int=yes            # Type int
  415. type_sql_integer=yes            # Type integer
  416. type_sql_interval_year=yes        # Type interval year
  417. type_sql_numeric(2_arg)=no            # Type numeric(1_arg)
  418. type_sql_real=yes            # Type real
  419. type_sql_time=yes            # Type time
  420. type_sql_timestamp=yes            # Type timestamp
  421. type_sql_varchar(1_arg)=yes            # Type varchar(1_arg)
  422. union=yes                # union
  423. union_all=yes                # union all
  424. unique_in_create=yes            # unique in create table
  425. unique_null_in_create=yes        # unique null in create
  426. views=yes                # views
  427. where_string_size=4096            # constant string size in where
  428.